<h1><?php echo CHtml::encode(Yii::t('site','My Open Issues')); ?></h1>
<?php $this->widget(/* 'application.extensions.ddcrosstab.*/ 'DDCrosstab',
    array(
        //'debug'=>true,
        'row'=>"CONCAT(p.name,' - ',m.name)",
        'rowLabel'=>Yii::t('site','Project/Milestone'),
        'column' => "ELT(i.priority, '".'1 - '.Yii::t('site','High')."', '".'2 - '.Yii::t('site','Medium')."', '".'3 - '.Yii::t('site','Low')."')",
        'columnLabel' => Yii::t('site','Priority'),
        'cellsType'=>'id',
        'cells' => /* 'COUNT(i.id)', */ 'i.id',
        'cellsLabel' => Yii::t('site',"Issue ID's"),
        'cellsLink'=>array('/issue/admin','crosstab'=>'userOpenIssues'),
        'from'=>'Project p',
        'leftJoins'=>array(array('Milestone m','p.id=m.projectId'),array('Issue i','m.id=i.milestoneId')),
        'where'=>str_replace(':userId',Yii::app()->user->id,"(i.ownerId=:userId OR i.userIdCreated=:userId OR i.userIdUpdated=:userId) AND i.issueStatus IN('swIssue/new','swIssue/accepted','swIssue/started')"),
    )
); ?>
